import numpy as np
import pandas as pd
from pandas_profiling import ProfileReport
admission = pd.read_csv("ADMISSIONS.csv.gz 19-49-59-485.gz")
icu = pd.read_csv("ICUSTAYS.csv.gz")
prescription = pd.read_csv("PRESCRIPTIONS.csv.gz")
/Users/fengyi111/opt/miniconda3/lib/python3.9/site-packages/IPython/core/interactiveshell.py:3441: DtypeWarning: Columns (11) have mixed types.Specify dtype option on import or set low_memory=False. exec(code_obj, self.user_global_ns, self.user_ns)
procedure = pd.read_csv("PROCEDUREEVENTS_MV.csv.gz")
profile_admission = ProfileReport(admission, title="Admission EDA")
profile_admission
Summarize dataset: 100%|█████████████| 43/43 [00:07<00:00, 5.46it/s, Completed] Generate report structure: 100%|██████████████████| 1/1 [00:02<00:00, 2.51s/it] Render HTML: 100%|████████████████████████████████| 1/1 [00:00<00:00, 1.23it/s]
profile_icu = ProfileReport(icu, title="ICU EDA")
profile_icu
Summarize dataset: 100%|█████████████| 76/76 [00:07<00:00, 10.76it/s, Completed] Generate report structure: 100%|██████████████████| 1/1 [00:02<00:00, 2.23s/it] Render HTML: 100%|████████████████████████████████| 1/1 [00:01<00:00, 1.09s/it]
profile_prescription = ProfileReport(prescription, title="ICU EDA")
profile_prescription
Summarize dataset: 100%|█████████████| 59/59 [02:37<00:00, 2.66s/it, Completed] Generate report structure: 100%|██████████████████| 1/1 [00:02<00:00, 2.57s/it] Render HTML: 100%|████████████████████████████████| 1/1 [00:01<00:00, 1.26s/it]
profile_procedure = ProfileReport(procedure, title="ICU EDA")
profile_procedure
Summarize dataset: 100%|███████████| 121/121 [00:33<00:00, 3.64it/s, Completed] Generate report structure: 100%|██████████████████| 1/1 [00:03<00:00, 3.86s/it] Render HTML: 100%|████████████████████████████████| 1/1 [00:01<00:00, 1.96s/it]